/*
 * Copyright 2025 the original author or authors.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package example.springdata.jpa.showcase.after;

import static example.springdata.jpa.showcase.snippets.CustomerSpecifications.*;
import static org.assertj.core.api.Assertions.*;

import java.time.LocalDate;

import org.junit.jupiter.api.Test;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.data.domain.PageRequest;
import org.springframework.test.context.jdbc.Sql;
import org.springframework.transaction.annotation.Transactional;

/**
 * Integration tests for Spring Data JPA {@link CustomerRepository}.
 *
 * @author Oliver Gierke
 * @author Divya Srivastava
 * @author Mark Paluch
 */
@SpringBootTest
@Transactional
@Sql("classpath:import.sql")
class CustomerRepositoryIntegrationTest {

	@Autowired CustomerRepository repository;

	@Test
	void findsAllCustomers() throws Exception {
		assertThat(repository.findAll()).isNotEmpty();
	}

	@Test
	void findsFirstPageOfMatthews() throws Exception {

		var customers = repository.findByLastname("Matthews", PageRequest.of(0, 2));

		assertThat(customers.getContent()).hasSize(2);
		assertThat(customers.hasPrevious()).isFalse();
	}

	@Test
	void findsCustomerById() throws Exception {

		assertThat(repository.findById(2L)).hasValueSatisfying(it -> {
			assertThat(it.getFirstname()).isEqualTo("Carter");
			assertThat(it.getLastname()).isEqualTo("Beauford");
		});
	}

	@Test
	void findsCustomersBySpecification() throws Exception {

		var dave = repository.findById(1L);

		var expiryLimit = LocalDate.of(2011, 3, 1);
		var result = repository.findAll(accountExpiresBefore(expiryLimit));

		assertThat(result).hasSize(1);
		assertThat(dave).hasValueSatisfying(it -> assertThat(result).contains(it));
	}
}
